package com.example.logistics_oa.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.comment_oa.pojos.JobcorresSubsidy;
import com.example.comment_oa.pojos_vo.BuTieChaXunVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author 安徽彭于晏
* @description 针对表【jobcorres_subsidy】的数据库操作Mapper
* @createDate 2022-10-17 17:28:00
* @Entity com.example.logistics_oa.domain.JobcorresSubsidy
*/
@Mapper
public interface JobcorresSubsidyMapper extends BaseMapper<JobcorresSubsidy> {

    public List<JobcorresSubsidy> selectAll(@Param("BuTieChaXunVo")BuTieChaXunVo buTieChaXunVo);

    public int updateButieStatusJin(@Param("jcsId") int jcsId);

    public int updateButieStatusQi(@Param("jcsId") int jcsId);

    public int updateButieMoney(@Param("jcsMoney") Double jcs_money,@Param("jcsId") int jcsId);

    public List<JobcorresSubsidy> selectZhiWeiIdAndName();

    public int insertJiLu(@Param("JobcorresSubsidy")JobcorresSubsidy jobcorresSubsidy);

    public JobcorresSubsidy selectOneByJcsjobid(@Param("jcsjobid")int jcsjobid);

    public List<JobcorresSubsidy> selectBumenAndBumenName();

    public List<JobcorresSubsidy> selectGenJuTiaoJian(@Param("jcsDepartmentid")int jcsDepartmentid,@Param("jcsDepartmentname")String jcsDepartmentname,@Param("jcsMoney")Double jcsMoney);

    public List<JobcorresSubsidy> selectBuTieXiangQing(@Param("jcsJobid")int jcsJobid,@Param("jcsDepartmentid")int jcsDepartmentid);
    public List<JobcorresSubsidy> selectBuTieXiangQingAnd(@Param("jcsJobid")int jcsJobid,@Param("jcsDepartmentid")int jcsDepartmentid);

}




